Writing a Query to Update Records Based on a Condition in SQL Server

Question

Ravi Vishwakarma · Answer

To update the Status column in your Orders table to 'Completed' for all orders where the
OrderDate is older than 30 days, you can use the UPDATE statement with a
WHERE clause.and 
Here is the query:
--using statement
UPDATE Orders
SET [Status] = 'Completed'
WHERE OrderDate andlt; DATEADD(DAY, -30, GETDATE());
-- Using one time variable 
Declare @LastDate DateTime = DATEADD(DAY, -30, GETDATE());
UPDATE Orders
SET [Status] = 'Completed'
WHERE OrderDate andlt; @LastDate;
Explanation:
UPDATE Orders: Specifies the table to update.SET Status = 'Completed': Sets the Status column to 'Completed'.WHERE OrderDate andlt; DATEADD(DAY, -30, GETDATE()): Filters the rows to update where the
OrderDate is more than 30 days older than the current date.
GETDATE(): Returns the current date and time.DATEADD(DAY, -30, GETDATE()): Subtracts 30 days from the current date, giving you the date 30 days ago.
This query will update and Status all orders placed more than 30 days ago to 'Completed'.
Read more
How to Write a Query to Find the Second Highest Salary in SQL Server?
SQL Query to Pivot Data from Rows to Columns in SQL Server
Help with Writing a Query to Find Orphaned Records in SQL Server
How to Write a Query to Get Top N Records per Group in SQL Server?
SQL Query to Find Duplicate Records in a Table in SQL Server

forum

Writing a Query to Update Records Based on a Condition in SQL Server

Anubhav Kumar

Can you answer this question?

1 Answers

Explanation:

Liked By